package com.jinmdz.fmis.dao.dao;

import com.jinmdz.fmis.dao.model.area.SystemAreaItem;
import org.apache.ibatis.annotations.Select;

import java.util.ArrayList;

/**
 * 行政区划Dao
 *
 * @author LiCongLu
 * @date 2020-01-17 13:19
 */
public interface SystemAreaDao {

    /**
     * 查询所有未删除行政区划
     *
     * @param
     * @return
     * @author LiCongLu
     * @date 2020-01-17 13:21
     */
    @Select(" select id,parent_id,parent_code,area_code,area_name,area_name_abbr,disable_state,as_province_city_county,sort,remark,version " +
            " from system_area where deleted=0 order by sort ")
    ArrayList<SystemAreaItem> listSystemAreaItem();
}
